--------------------------------------------------------
--  DDL for Table SYS_RULE
--------------------------------------------------------

  CREATE TABLE "APPLICATION_RULE" 
   (	
	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
  "RULE_ID" NUMBER(8), 
	"RULE_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"RULE_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"DESCRIPTION" VARCHAR2(255 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE)
   ) ;

   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_ID" IS 'RULE ID. TYPE GEST';
   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_NAME_LOCAL" IS 'LOCAL NAME OF RULE';
   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_NAME_ENGLISH" IS 'ENGLISH NAME OF RULE';
   COMMENT ON COLUMN "APPLICATION_RULE"."ACTIVE" IS 'Y/N TYPE OF ACTIVE RULE';
--------------------------------------------------------
--  DDL for Index SYS_RULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_RULE_PK" ON "APPLICATION_RULE" ("RULE_ID") ;
--------------------------------------------------------
--  Constraints for Table SYS_RULE
--------------------------------------------------------
  ALTER TABLE "APPLICATION_RULE" MODIFY ("RULE_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_RULE" ADD CONSTRAINT "SYS_RULE_PK" PRIMARY KEY ("APPLICATION_KEY", "RULE_ID");
